SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001891s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1012151 LIMIT 1 [ RunTime:0.001571s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1012151 [ RunTime:0.006275s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (448782,229166,1010139,550017,713437,546486,930343,642166,1029327,196475,947697,465754,739836,417413,192812,154345,590804,704775,855939,924635,733498,326066,951156,1042311,1028121,629894,689468,116048,720208,414695,815941,18015,321183,843481,646329,349074,613099,630888,190805,578128,174541,152522,711412,875612,960886,268914,501460,6213,723252,367107,849812,944171,1022709,608320,750960,955556,962481,425163,22963,670297) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.054780s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1012151 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001444s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1012151 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.008427s ]