SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001182s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1010813 LIMIT 1 [ RunTime:0.000379s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1010813 [ RunTime:0.001637s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (137492,700217,696214,404937,991700,325876,202216,449416,638512,786210,778413,494662,455114,56607,372285,37285,821058,857099,237205,372509,190065,934418,35881,860325,444390,647482,219988,303549,309066,1002130,539981,107531,862627,288345,302289,600361,82203,309378,947708,105655,172580,789843,541228,165542,425022,430062,261048,989396,819627,884161,596227,932673,348774,820510,938650,79039,252078,274279,800355,559637) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001495s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1010813 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000346s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1010813 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000479s ]