SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001149s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1019321 LIMIT 1 [ RunTime:0.000372s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1019321 [ RunTime:0.001756s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (509461,23147,831887,990810,417456,546341,117720,896470,361208,573589,222149,317399,914954,262884,765265,542426,602115,110193,876681,86709,864858,805564,97505,1011033,511664,435846,846870,813216,969445,103834,800666,186800,953563,1009762,734124,366340,758895,107002,940082,766334,577134,826171,597355,681061,347657,361178,335697,169938,737,19595,701279,289080,22266,35355,738206,248366,44008,439739,918687,497759) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001288s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1019321 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000419s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1019321 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000555s ]