SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001301s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 115941 LIMIT 1 [ RunTime:0.000759s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 115941 [ RunTime:0.004310s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (416843,380661,577829,41246,785299,421256,522631,870832,636790,104465,941083,472693,503979,132061,115978,9680,325645,163572,475079,580909,455484,27848,1044745,506488,647719,614588,148935,166077,230002,619976,190323,370427,567123,415987,826282,860699,237424,64602,6375,791210,1044623,1039050,41495,817872,784265,135133,525529,859555,792099,661492,674515,567253,1015947,489364,332850,594754,372674,50614,9608,456501) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001834s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 115941 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000598s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 115941 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000542s ]