SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001198s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 471704 LIMIT 1 [ RunTime:0.000381s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 471704 [ RunTime:0.001669s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (920080,19098,866272,67940,849809,52150,449178,415285,293421,399430,686744,87642,471461,1045721,308944,1001963,385733,475659,596466,113675,216219,701518,186275,389715,97686,70891,660314,711587,701856,86602,59483,440766,981041,446865,244256,565580,88082,921492,14824,204574,278634,829871,395546,1045710,207857,140555,1048378,371347,679709,34295,471563,521739,483020,456699,659324,50612,345943,592575,684642,207238) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001309s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 471704 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000349s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 471704 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000648s ]