SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001808s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 289294 LIMIT 1 [ RunTime:0.000513s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 289294 [ RunTime:0.001907s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (569667,1010275,325206,224717,520889,403514,507286,664561,1003761,284059,738033,113007,755167,564104,510319,627300,884734,129910,662948,357356,331122,208534,793950,168541,393926,95166,700688,750600,323183,15050,580351,369840,138204,628060,896194,147247,237777,587911,611523,308540,796782,85456,384863,654124,736423,105370,16932,892707,215561,134945,779690,289790,234254,179909,292512,554364,914854,744501,697544,216749) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001060s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 289294 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.006211s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 289294 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.007034s ]