SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001191s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 457739 LIMIT 1 [ RunTime:0.000336s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 457739 [ RunTime:0.001846s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (720746,101857,606576,238564,264519,745776,618839,850973,410749,716007,91607,303456,180321,415048,502634,979558,30566,542201,824244,782408,145639,54574,611255,1012382,996984,110347,686544,720553,872499,781432,553829,790248,542835,374007,682138,1016184,303487,708630,347534,447879,114890,237851,103002,145887,411962,937352,359685,1023452,302816,1019275,213948,548879,1045553,224357,673703,213388,174582,596074,922054,1030428) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001262s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 457739 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000448s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 457739 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000583s ]