SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001211s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 120413 LIMIT 1 [ RunTime:0.001317s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 120413 [ RunTime:0.002749s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (803199,511025,63456,1013134,282175,251301,614977,769037,506766,698392,459111,250141,163538,431795,663572,741251,283949,354353,461696,742839,799600,386504,523715,485999,568256,143153,139025,894556,830783,236777,807128,257213,235322,990047,351619,20375,63437,304382,202946,1041068,12970,560414,447900,199014,604335,830514,250432,253098,244128,497976,861715,469142,757545,355861,173093,276796,530407,42505,946368,251132) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002276s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 120413 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000465s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 120413 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000443s ]