SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001224s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 311416 LIMIT 1 [ RunTime:0.000405s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 311416 [ RunTime:0.001615s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (888143,713882,646439,619146,210833,349109,667062,591825,227840,574364,184927,336307,1043003,359061,39767,962091,537251,712060,654705,619502,1011633,338954,197610,113856,289068,158477,318192,964288,983369,851158,636684,1042173,44212,467893,157116,1019829,321199,680883,676750,753807,327582,407462,433277,877057,603446,675548,531864,712213,618837,576277,564761,184703,474127,34939,587951,254400,888554,303351,45533,698305) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001225s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 311416 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000455s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 311416 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000704s ]