SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001562s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 475080 LIMIT 1 [ RunTime:0.001583s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 475080 [ RunTime:0.002287s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (283061,848101,992385,54608,173609,255762,496893,512149,1027393,841396,688600,984061,547545,246933,431249,667275,618372,225345,407293,868501,819601,837221,713816,12480,506478,532087,764104,776937,761436,356015,738840,238093,812435,57938,618441,197424,419352,105182,614183,334178,223494,559924,200386,49521,256430,499535,154692,303681,643380,37678,60859,537712,202723,386644,447397,392718,716192,360533,702837,411653) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001830s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 475080 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000476s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 475080 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000574s ]