SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001124s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 591201 LIMIT 1 [ RunTime:0.001048s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 591201 [ RunTime:0.003193s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (450313,425436,1025101,181249,577041,51878,428200,809489,340329,708686,117608,139748,699968,248760,295198,563515,705480,175898,584050,399932,244469,233424,634363,689410,904513,170039,352513,20556,880497,1018391,776260,43857,194373,191925,73229,647469,203040,691256,473677,607663,673447,702136,542905,163548,720726,290708,650487,672586,6976,401110,370033,997175,86705,832575,68179,345968,963947,600516,524472,118877) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000994s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 591201 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000427s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 591201 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000448s ]