SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001470s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1038072 LIMIT 1 [ RunTime:0.000551s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1038072 [ RunTime:0.001885s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (695452,605901,640573,207614,655348,1016729,79491,889565,803001,341594,725688,579777,336578,659125,646410,362467,281244,671287,549380,973385,989991,829188,486812,809497,643349,622835,581213,384873,158936,444650,831922,287553,523184,470429,546462,897250,635289,339850,491142,485593,840324,61738,923577,34036,898956,291116,999933,436900,546646,103513,544858,779326,1002334,863218,274236,736047,866504,111111,940607) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001087s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1038072 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001004s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1038072 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001361s ]