SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001277s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 204169 LIMIT 1 [ RunTime:0.000386s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 204169 [ RunTime:0.004462s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (40941,420749,1006682,776662,486061,953937,66343,228188,165571,938897,542850,475339,592862,64293,343965,752522,106375,656690,764354,183441,746691,847705,773589,798427,255905,588422,849838,746610,99141,73486,764670,542502,738089,798750,295093,562230,986797,313485,580292,267795,826855,548500,944326,311538,555126,975959,4913,478433,767596,937691,905573,10157,382999,130962,388023,333596,1029430,636436,258150,400754) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001664s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 204169 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000536s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 204169 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000542s ]