SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001178s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1019899 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1019899 [ RunTime:0.001954s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (923691,961367,817418,755831,442990,551903,196664,175957,39743,141865,210564,179878,353145,248689,862919,703431,873760,133886,115453,757153,177264,344620,325041,55431,514165,206466,204935,814044,228855,1043834,27251,611475,558434,1016410,906126,955552,532698,546364,504253,963335,441471,94687,482320,123705,451361,637658,650374,21109,746764,28827,498010,339462,674317,539814,542647,680620,118723,111402,730043,418391) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001084s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1019899 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1019899 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000450s ]