SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001385s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 109631 LIMIT 1 [ RunTime:0.000411s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 109631 [ RunTime:0.002462s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (694718,866888,124470,278953,740819,935551,945159,53715,8138,1044971,989652,530392,952160,836762,858526,560179,661762,936523,121636,1027603,1004795,529668,945376,707052,356133,751298,255706,496384,598459,921563,511456,574350,587628,406924,284702,32552,109077,113085,777140,1015079,181224,148923,395709,125841,731096,260866,295228,794848,525958,569657,656010,278959,182052,373663,690802,999213,354520,480120,211897,952113) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001112s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 109631 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 109631 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000617s ]