SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001276s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 801445 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 801445 [ RunTime:0.004002s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (591573,121304,711367,393258,582087,914546,458767,575924,235256,663623,50557,1040601,767221,998735,244569,815476,309404,473984,411234,447850,401094,830136,932082,987521,964351,654579,570918,668688,37596,362973,457011,1043187,25382,173784,432508,693521,466237,320757,257199,1032966,833998,674112,737473,749276,646080,947058,661015,914188,864643,102100,988199,327032,875943,580383,686061,316453,80881,453405,773170,614365) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001142s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 801445 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000603s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 801445 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000501s ]