SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001128s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 117411 LIMIT 1 [ RunTime:0.000362s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 117411 [ RunTime:0.001787s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (413469,36150,47633,565933,789104,977264,960191,177778,994692,174120,803360,503732,174946,178640,553560,776609,571562,907627,373427,552484,805440,682251,507570,633059,930825,22059,287415,442358,52852,1027331,825341,154784,1039349,751394,440339,585429,5775,783313,767856,610803,545437,52594,809401,520865,937680,987440,673321,19560,227987,591603,824940,842962,346455,995437,205360,403207,981082,99308,361956,787498) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001934s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 117411 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001074s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 117411 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001234s ]