SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001157s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 103984 LIMIT 1 [ RunTime:0.000309s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 103984 [ RunTime:0.002012s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1042947,817555,5195,493917,510082,914194,440591,80186,984970,241634,694331,126734,374561,910480,494789,153440,330668,652906,627528,867117,251324,936927,525485,130550,488381,324760,1034319,653500,510428,492834,757230,982985,995744,411541,665437,396856,859201,246534,319765,985121,866381,257010,252355,77270,437748,35934,956375,8894,159291,450603,652594,970000,895592,453480,733693,409444,407697,1043923,219579,596231) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001043s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 103984 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 103984 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000849s ]