SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002373s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1028509 LIMIT 1 [ RunTime:0.000489s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1028509 [ RunTime:0.005036s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (166074,894110,154373,744086,531628,358292,237583,152,903983,795363,844491,634297,1011849,753852,327067,505627,895102,246996,183922,653713,868340,365217,861998,318707,804499,590822,461936,221726,118054,560648,293971,91432,401812,986421,1037866,331358,314803,510975,846609,446447,555662,703998,243133,15809,966452,97409,152422,145945,590854,1006405,489609,465281,159040,692485,81180,316456,775914,137832,35497,650725) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001037s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1028509 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000589s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1028509 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002892s ]