SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001515s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1047273 LIMIT 1 [ RunTime:0.001246s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1047273 [ RunTime:0.001756s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (254740,154897,567687,132452,430726,1031387,260541,630668,1028061,18621,62359,659432,735788,476578,647898,917518,720211,119211,240373,649328,497135,202508,714777,947131,790025,651010,1047117,551845,31092,1026411,294963,423494,187628,864642,905505,121500,613930,894017,56245,131721,986332,804059,1004115,308480,134462,37203,152382,110932,531084,712351,549131,1001504,809338,124871,296664,724137,599151,80827,832969,135135) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001134s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1047273 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000340s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1047273 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000532s ]