SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002912s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 365540 LIMIT 1 [ RunTime:0.000392s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 365540 [ RunTime:0.001483s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (393883,265136,853305,118145,975665,21859,848623,19374,458478,453222,562831,64037,1041070,189145,872681,351576,528263,768498,1013261,833484,547145,860820,1027571,778574,595095,131637,615959,713788,123992,298021,682428,414220,644585,109737,196609,394345,61969,774241,979929,47301,709754,106353,332329,329946,32925,770356,659390,69274,541311,515320,93060,272920,628069,462907,875789,561072,556362,411062,92298,144021) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 365540 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001267s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 365540 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000765s ]