SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001118s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 544219 LIMIT 1 [ RunTime:0.000319s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 544219 [ RunTime:0.001600s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (470343,9332,80074,1316,833048,706402,596283,169835,366073,369867,823166,136292,449561,680221,156840,596771,290438,236446,664495,81627,914555,896605,553431,457373,786238,86339,729284,1034639,456990,729319,250568,580727,179037,106061,705837,493009,984111,623079,922113,738461,993203,197271,850961,820630,255491,790898,865637,290901,533646,683155,682386,662341,786802,800600,631184,602468,71876,417451,668904,531794) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001033s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 544219 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 544219 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004602s ]