SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001261s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 5082 LIMIT 1 [ RunTime:0.000346s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 5082 [ RunTime:0.002711s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (183650,888023,715523,50070,55889,421858,945734,270733,1012755,236652,477839,755280,183664,58738,85321,1030816,314604,1048109,657900,630602,114276,49658,147114,180669,209476,270652,882243,681543,641032,438305,121935,747782,46650,469956,127132,598417,141754,142846,28064,888873,942782,80630,529298,344580,765472,254629,488608,1003225,275924,923320,475708,217473,166241,334201,113063,725750,91553,280200,276699,461922) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001139s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 5082 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000334s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 5082 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000704s ]