SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001150s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 643591 LIMIT 1 [ RunTime:0.000355s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 643591 [ RunTime:0.002750s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (507742,636829,503759,252383,956916,1004456,607735,663789,388225,345964,1007817,515793,567139,663307,124424,1026161,206241,886268,147101,839701,492924,936375,1035673,1012208,808388,923581,756457,550569,832432,364617,29330,1009987,416866,178874,360060,498836,736938,381673,918090,744072,431382,497395,819925,779240,813269,987515,255062,436212,441612,933288,442772,440124,914635,1010610,475345,265067,32878,427289,714596,48360) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001285s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 643591 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 643591 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000395s ]