SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001218s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1028028 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1028028 [ RunTime:0.002253s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (274133,818987,820787,270772,479644,869009,318599,95491,493273,844283,753405,659059,204782,445887,964247,130269,328124,657419,213741,628925,576658,606049,595954,534430,53686,543935,147248,946440,935310,182694,512482,844001,572265,724295,251490,968469,676406,553967,981350,1009189,573469,511187,995635,956540,284075,386908,111228,631004,477200,818881,21269,980356,320699,719557,527467,176816,943381,899880,40001,732259) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001153s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1028028 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000406s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1028028 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000516s ]