SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002452s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1039012 LIMIT 1 [ RunTime:0.000373s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1039012 [ RunTime:0.002195s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (620455,837837,608272,684193,827168,621065,857782,357808,514843,260344,753022,385933,255060,1017861,92990,550010,426750,845107,317714,1012225,265568,99652,1000397,903964,412826,670862,952010,414105,90252,828743,252347,531961,155725,200417,647435,789170,549335,674174,179017,34660,655186,995766,1010707,14697,185449,900293,657717,506820,1040321,207842,1022699,453195,227052,61366,168134,45517,996579,776721,393614,344338) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000974s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1039012 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000339s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1039012 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000626s ]