SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001250s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 206838 LIMIT 1 [ RunTime:0.000397s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 206838 [ RunTime:0.001679s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (450182,149188,979230,194034,117542,426710,955375,119436,961370,777094,943718,601085,253561,133647,727906,463397,51905,73502,512989,635631,61491,1013807,471252,378918,401912,381614,344107,471338,661010,10714,649385,363570,87787,129784,230727,245516,106899,686878,811423,53713,564222,857077,900384,537765,134443,160084,733129,1003501,424342,976811,328327,1012491,564225,286265,558333,562859,60019,328826,268697,1040968) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001111s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 206838 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000438s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 206838 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000560s ]