SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001469s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 544859 LIMIT 1 [ RunTime:0.000742s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 544859 [ RunTime:0.001499s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1028664,559465,69839,204727,930983,291513,314018,141065,228944,368406,378288,412554,429848,90733,176347,991182,912015,661921,309854,781524,494981,431937,752077,610144,250020,299873,313923,469269,465406,942113,249020,811983,519804,33569,360494,557269,58255,761680,723331,297181,935011,1046940,965961,207515,132290,601421,947684,143949,346480,414942,537350,531058,335706,769222,760390,963749,373841,620757,196128,996481) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001107s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 544859 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000491s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 544859 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000626s ]