SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001121s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 544576 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 544576 [ RunTime:0.001449s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (535819,203782,27494,977601,1011925,1003354,112481,878015,881328,543268,252673,373994,258259,649538,217250,428305,896524,793613,625669,574532,633809,842712,127542,561438,17202,37453,262804,418475,506550,367734,388955,411213,120541,708923,953185,944902,996264,653547,428615,694843,817023,745765,59779,876320,343793,654969,99590,253415,935539,560413,79712,20570,914415,422090,803843,161526,258461,378680,305096,794654) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000964s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 544576 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000420s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 544576 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000484s ]