SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001188s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 553730 LIMIT 1 [ RunTime:0.001093s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 553730 [ RunTime:0.001759s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (76445,408240,716247,645489,501590,760675,915142,477874,166564,5162,915290,80895,506519,811661,374638,936523,21090,522207,235350,1011960,180022,50445,598946,477055,63973,121878,731262,721428,165616,638918,241488,929332,635676,206825,866091,198593,679416,969488,1006842,210223,787372,136928,508539,737296,374201,949180,790956,484061,977183,105257,466539,244879,88392,643035,213770,507846,204771,484178,199679,488882) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.026356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 553730 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000512s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 553730 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001895s ]