SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001342s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 534500 LIMIT 1 [ RunTime:0.000373s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 534500 [ RunTime:0.001626s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (764397,804889,477132,265893,915365,391246,685641,102176,926130,734387,858640,758024,64150,561879,715503,745769,718497,924813,304673,394186,627439,203541,299126,820355,790059,130608,448925,586664,976381,671374,241087,785124,160126,889113,539983,109775,106525,557100,449496,992288,154358,613461,619659,272100,988264,735939,405967,38622,724584,912826,1027195,38093,227330,135216,1038438,608089,180116,384292,758408,171569) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001211s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 534500 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 534500 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001202s ]