SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001134s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 507203 LIMIT 1 [ RunTime:0.000383s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 507203 [ RunTime:0.001720s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (243472,568407,707122,101032,724762,4186,329369,757968,650931,714329,434842,413035,728801,546656,928846,305355,743990,628024,786986,88280,240189,577560,861686,277313,444483,687742,141225,362443,712332,698031,637751,455943,470747,660670,571941,988279,1031999,939631,486837,738353,132062,737414,632247,146826,723854,250576,519912,574510,67030,57873,594952,381678,344236,349948,359842,861052,436953,108968,748755,646930) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001155s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 507203 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 507203 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000511s ]