SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001174s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 41518 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 41518 [ RunTime:0.002378s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (13598,797557,204476,993874,336245,40785,642092,402334,624888,222686,334462,558613,886824,890132,569544,18581,891724,839557,790729,264622,539624,211424,108407,542333,899516,277301,816926,661181,42273,761623,884787,187959,837023,755674,119560,357264,942485,712944,944506,76142,1045042,988849,818112,579294,1048372,203870,729505,706658,975416,329823,1017191,177691,474666,516369,725744,1009179,702690,488269,971769,232830) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001029s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 41518 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000334s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 41518 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000574s ]