SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 51993 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 51993 [ RunTime:0.003629s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1029671,346977,721084,102680,583637,269624,611642,693163,136639,522643,507693,118703,224588,33980,758960,481687,792202,642661,618129,912650,192375,932618,1003206,884826,289453,287961,53816,909220,175400,787962,945159,442893,736451,844363,670972,643846,196761,187299,765158,300318,899470,869206,156112,348978,639126,1018823,875681,352583,187497,293133,1015529,786317,261358,253384,198270,212960,475291,586973,638582,126580) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001736s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 51993 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000417s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 51993 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000555s ]