SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001481s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 543829 LIMIT 1 [ RunTime:0.001002s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 543829 [ RunTime:0.002435s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (408231,507361,590235,10158,629349,361827,273942,999965,557434,960701,354599,299112,731812,912229,958125,554403,401154,204573,186984,363751,188639,787011,976375,303608,217145,486817,969891,745133,318201,257759,902590,974680,984645,740461,1046143,381002,257849,119193,171830,795148,285438,370268,980037,623863,51149,998930,995270,647903,447311,469231,296610,690919,960055,1015149,481393,407792,1025118,197072,306030,108645) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 543829 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 543829 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000579s ]