SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001259s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 447442 LIMIT 1 [ RunTime:0.000362s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 447442 [ RunTime:0.001829s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1010747,954971,708779,761201,242603,183800,831774,155623,484734,203787,494094,1045553,580774,106217,343395,1000167,205665,753407,196193,972630,245693,340781,272245,491444,573163,658375,540130,514589,685559,640085,786126,504,711775,768388,909232,178100,984201,877069,259519,660789,489156,533829,370018,752715,156352,174879,138468,803560,106545,716355,156933,983328,132404,883162,385002,801942,834882,893949,113933,847475) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003417s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 447442 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000530s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 447442 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004266s ]