SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001434s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1043678 LIMIT 1 [ RunTime:0.000365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1043678 [ RunTime:0.005005s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1009102,83824,952767,902761,951432,55654,747028,156977,922791,257492,945514,722912,962351,6615,90801,632465,409013,872962,970368,480308,706546,500558,582233,870757,255396,2657,971650,111972,149872,53535,435718,487524,756718,170554,793257,446865,288448,473068,662464,924179,174628,885197,291777,264862,338310,1035493,329327,264872,711152,209312,193951,344858,659777,803333,566952,438723,233020,405178,93341,535783) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001238s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1043678 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000551s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1043678 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000929s ]