SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001212s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 975110 LIMIT 1 [ RunTime:0.000301s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 975110 [ RunTime:0.001560s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (482017,404543,935209,798531,711984,836742,361656,349441,509045,428764,220231,124782,890680,25640,1005751,273533,244873,634653,413883,800088,390177,319722,1006173,324131,34117,1016940,66396,686614,624716,167741,225513,128627,396328,162998,1018880,113705,898393,806288,511115,768120,522989,127408,70465,61911,244638,540968,156745,325271,192274,369434,160650,459958,792586,50404,921034,1005787,175129,114864,686633,1011455) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000931s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 975110 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000338s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 975110 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000537s ]