SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001312s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 414241 LIMIT 1 [ RunTime:0.000371s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 414241 [ RunTime:0.001634s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (607216,221784,333543,74915,975649,680722,117739,68762,126463,843691,837013,799141,814758,812045,359089,190236,571453,522413,413500,651392,846589,118895,621406,264205,295165,871921,397198,161740,624812,386561,61395,550175,411556,179456,210099,146744,296670,335459,985443,438358,896825,591144,815912,601226,491872,1008808,387371,423794,628340,444912,559363,1046533,769718,437213,616271,894790,499539,868170,783716,593624) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001021s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 414241 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 414241 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000477s ]