SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001185s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 194809 LIMIT 1 [ RunTime:0.000303s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 194809 [ RunTime:0.004879s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (275271,496355,486394,907534,79865,324857,711699,881800,88242,13327,596098,89308,977875,138782,978521,412945,351188,404218,889111,962968,987004,614110,338182,112320,622107,16053,741216,633914,216273,765132,443389,976650,81095,707739,902593,104170,249206,361884,19944,640223,307435,38300,925614,841635,480975,386753,838250,450457,748052,322333,483922,621428,1027785,1033359,1030833,252914,898700,908560,509417,762932) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001437s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 194809 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000439s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 194809 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000550s ]