SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001032s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 522851 LIMIT 1 [ RunTime:0.000368s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 522851 [ RunTime:0.001961s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (269658,443428,457699,244290,632448,885277,78275,695358,240867,44669,849502,936743,342117,278751,559848,402655,511296,475124,843324,719124,812720,546309,522424,704011,472527,874364,280020,588682,967667,679172,916281,615443,583104,820040,62703,630854,919041,21681,244951,821432,369627,116963,29691,667757,965542,386034,976071,559058,707597,1039781,571444,813643,423653,757154,488031,983727,552775,231949,572100,321016) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001186s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 522851 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 522851 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000580s ]