SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001234s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 802499 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 802499 [ RunTime:0.002022s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (342642,1008215,306503,747807,973807,337789,884807,665285,1039410,857595,784569,291681,134620,220206,28535,382312,112005,264438,580292,476380,613319,446588,264878,182013,707226,955473,744729,914046,181337,454056,957704,975336,741760,875865,252671,208861,1020675,103355,485849,122463,469801,791138,400448,828784,543127,228204,27436,40181,93675,499936,25701,791777,515599,494326,322701,609577,7656,727094,996055,230964) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001071s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 802499 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000402s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 802499 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000513s ]