SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001309s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 973080 LIMIT 1 [ RunTime:0.000365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 973080 [ RunTime:0.002983s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (757184,187531,358240,788399,534676,865750,406571,260637,37514,970251,775902,536339,73411,560269,498493,550838,652327,622966,994345,422445,741945,624531,823664,24393,834947,1041389,823177,174796,264712,513299,218619,400950,1027758,939934,752162,1010817,111035,1014885,727915,687269,86738,1021148,590679,129560,565625,788648,582233,1038585,1014428,80277,373093,991694,634653,587652,4192,407716,925633,416939,718885,232058) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001068s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 973080 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000462s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 973080 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000542s ]