SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001363s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 401867 LIMIT 1 [ RunTime:0.000381s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 401867 [ RunTime:0.001838s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (886117,85637,86926,607463,513022,1019806,716543,86348,232419,365134,809460,601673,149319,423050,733789,262648,307076,309540,1005584,400999,718426,910694,192956,769385,998643,326677,879904,57672,905356,859975,507325,1029173,700487,774648,64596,963635,567035,554038,236903,395083,696121,785444,52892,344404,552897,507991,926620,235525,338755,1040795,176922,515136,140663,92142,313186,401605,690650,187460,25484,358141) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000975s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 401867 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 401867 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000578s ]