SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001179s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 348212 LIMIT 1 [ RunTime:0.000625s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 348212 [ RunTime:0.002708s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (661079,592366,987016,558808,550383,150250,195144,843693,557025,449903,470036,907774,311478,465209,952093,104294,220669,194012,694230,846078,115053,346156,16810,273463,508657,934882,817291,608563,768243,401024,536150,997166,683189,516905,344101,319164,782341,588205,596442,340711,44022,780558,645866,992840,446790,842735,302465,191588,194849,477745,427605,986401,917659,879613,233882,989965,133980,279103,315260,803764) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 348212 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000597s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 348212 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000702s ]