SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001147s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 65738 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 65738 [ RunTime:0.001452s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (583901,777548,742820,544102,585288,106441,751472,127687,45661,1011831,351648,593580,629006,1032622,884141,826650,561436,870800,265984,1006731,640096,672769,445503,218967,336049,22156,64974,613948,37454,542724,387564,809769,494600,624002,969496,786848,374735,711105,581461,323535,834326,194389,642134,901778,285273,960486,995394,102375,1021006,28108,814302,526485,335069,638340,171715,90652,261624,308057,422142,19365) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000996s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 65738 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000341s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 65738 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000396s ]