SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001267s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 513728 LIMIT 1 [ RunTime:0.000362s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 513728 [ RunTime:0.002091s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (223721,80866,402320,91423,328142,719236,867344,380299,225713,278346,715954,913867,1035823,953938,426951,453590,352773,96186,1020611,969174,967800,401515,879043,87722,811454,1040844,656762,815006,1042344,845130,1036245,247515,754610,533387,522333,1009501,917256,1005722,64810,703139,161180,935165,676039,656019,524315,228942,226317,48054,627299,977973,191744,869978,702860,207398,400262,133370,414687,585962,338913,560044) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000979s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 513728 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000402s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 513728 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000404s ]