SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 107800 LIMIT 1 [ RunTime:0.001104s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 107800 [ RunTime:0.001529s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (640936,213801,578963,1025121,177559,728510,337734,736836,716703,256268,281757,820356,864129,416824,483551,823414,605705,942524,119526,863403,953794,502303,969614,159613,435048,517437,1019482,392032,469049,874600,293100,469005,949671,579199,375517,537317,1026105,559885,958631,259650,196300,433926,678747,58161,111411,759289,272044,867753,418084,230640,303870,519466,1183,724396,279974,314041,554394,856415,901393,49718) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001089s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 107800 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000422s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 107800 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000796s ]