SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001211s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 109020 LIMIT 1 [ RunTime:0.000357s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 109020 [ RunTime:0.002020s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (780470,907312,72115,731035,503316,494111,63119,990235,771185,572277,972544,472423,673002,375015,812422,292500,393643,224165,722907,151778,767397,582923,919723,776968,187928,302832,246984,179809,441404,768096,436894,183389,220727,1023171,177325,8427,430344,378399,884719,162395,685919,354630,540575,130297,294832,540664,303516,226629,176763,428403,310053,132907,647170,159507,750522,3058,391672,140956,475961,119644) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 109020 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 109020 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000658s ]