SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001285s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1180 LIMIT 1 [ RunTime:0.000373s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1180 [ RunTime:0.003203s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (3692,800993,214320,564181,131790,720974,745595,389517,98981,743770,378352,809126,12334,406850,776068,370244,802980,184510,296903,760585,50089,804959,102367,83014,19581,1017056,781882,334840,806683,839082,172218,62009,852862,682071,1042422,335726,559910,304105,679739,445022,1040976,910909,864755,719380,687661,187652,1013001,312950,68225,857428,399160,473573,724985,928383,455542,47831,301573,910245,408457,943482) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001188s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1180 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1180 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000636s ]