SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001246s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 412170 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 412170 [ RunTime:0.001583s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (63603,67251,357597,184942,637330,42964,680282,963443,1037023,875014,446070,338648,322330,130648,641798,399751,313944,408631,761331,172114,967753,789340,121152,549740,599878,537577,180362,697333,473935,905323,773516,574889,907730,307117,777928,240011,259648,596758,570058,807552,867024,713635,869385,485731,988644,263021,439593,462726,216424,417848,890227,589534,470657,975886,1033272,609402,229802,313928,781622,112903) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 412170 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001325s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 412170 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000617s ]