SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 711892 LIMIT 1 [ RunTime:0.000336s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 711892 [ RunTime:0.002135s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (245018,42345,656333,634407,105989,941340,457062,264478,199786,530073,13156,718248,306209,472582,483487,320040,600897,1013658,335490,264584,83513,249238,257475,298021,596395,523925,24192,196050,846223,801588,237411,591033,316875,398432,215798,1008992,561859,834198,685976,613088,689579,163833,211181,395954,130642,517393,871882,874180,88995,685473,870172,328616,657487,582732,853182,386346,830008,690735,706365,701266) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001544s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 711892 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000402s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 711892 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000547s ]