SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001196s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1046462 LIMIT 1 [ RunTime:0.000411s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1046462 [ RunTime:0.002180s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (490511,774850,1048410,1037567,308428,798106,38279,744125,201456,677129,907479,303835,872313,626258,793732,765540,127297,412505,411671,616928,340392,696562,318988,50515,69878,669802,395477,584831,332089,729007,160476,105088,583712,111830,1041998,590644,357285,753048,838558,433264,68536,535592,378366,589913,123333,334920,664132,13181,647000,213896,802790,516952,29473,537349,519538,412337,897507,1014177,152430,110902) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001419s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1046462 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1046462 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000478s ]