SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001248s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 124614 LIMIT 1 [ RunTime:0.001383s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 124614 [ RunTime:0.001480s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (216015,210869,493886,239761,125885,717955,772164,238615,76477,249676,390900,179461,713725,288294,451095,757361,965044,409181,912813,325811,431394,206524,279349,152843,152219,641920,874876,993013,750531,576703,346919,752568,942315,765140,143118,477910,688882,303451,768489,438642,719460,420976,899976,587737,760348,705554,1030493,530928,194806,280275,262949,799154,487101,705892,727342,499200,499342,939614,789874,226697) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001056s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 124614 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 124614 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000569s ]