SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001623s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 39609 LIMIT 1 [ RunTime:0.000426s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 39609 [ RunTime:0.003072s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (323585,951719,791197,248509,908547,388061,680038,311696,456476,1034649,79348,109294,728550,187601,678252,178186,299910,275329,1040436,1011189,341725,974232,541952,470366,388803,247976,783889,110648,791025,192150,842661,425025,121370,559753,159066,756687,981029,473435,23593,340389,167725,610755,82575,959439,477091,255057,659139,671723,302616,407571,451333,1044665,731189,816587,460696,347239,164210,847524,559221,137631) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001316s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 39609 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000467s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 39609 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000712s ]