SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001274s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1007774 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1007774 [ RunTime:0.001799s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (10955,203810,676607,234061,740386,174460,449720,331154,198076,210462,199998,140481,75546,15659,877597,586682,428415,630722,642063,200463,876009,976114,3704,535952,160736,923370,919902,872659,214723,385227,168538,561873,527232,71436,670537,749050,948107,870729,615800,948389,227465,750146,814955,986896,295515,708980,629792,5814,579167,664657,324864,753334,679150,582136,82989,216308,411475,479392,1041495,648883) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001270s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1007774 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003071s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1007774 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001302s ]