SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001217s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 581409 LIMIT 1 [ RunTime:0.000377s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 581409 [ RunTime:0.001748s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (181559,860118,470039,440481,849230,342760,471058,715277,933258,765245,836480,609202,656373,555375,893160,888724,647087,799654,352989,994342,924957,455116,12836,871145,698740,178894,719966,899898,1042718,851534,838730,538471,235106,246733,408839,953336,160915,417034,860116,984517,113949,199187,97815,248866,402317,1000093,894852,421884,113571,954372,955260,992621,848501,904632,450468,418248,711523,129025,1031092,773975) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001599s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 581409 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 581409 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001039s ]