SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001220s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 413831 LIMIT 1 [ RunTime:0.000435s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 413831 [ RunTime:0.002181s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (839372,916888,956709,301699,869582,792023,195747,220680,243698,1016638,387338,898407,323593,515116,482085,11165,703530,379015,540015,133156,867718,94931,11418,655475,678294,52842,306316,1039061,118407,71302,419633,922269,14043,1037815,914871,167152,938570,1036505,1048005,911514,380929,711930,914980,634412,821064,143115,887903,56669,1014064,671161,34882,112738,302555,115026,557455,572226,941450,768630,80170,368466) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001081s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 413831 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000441s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 413831 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000581s ]