SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001329s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 535554 LIMIT 1 [ RunTime:0.000356s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 535554 [ RunTime:0.001724s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (214157,291498,477315,546168,764566,464780,989870,819111,719590,758416,194065,184237,139480,354293,674064,939119,967430,393993,48010,60514,356388,481745,885198,926392,614510,16481,637041,16752,427602,180942,621779,252254,702064,972061,172866,325119,67362,514345,545424,291600,935408,102793,134673,406648,28082,57114,673974,315662,277010,985540,818755,1035494,255334,278610,757998,958456,213082,261649,46857,853090) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001040s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 535554 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 535554 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000771s ]