SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001011s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1018783 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1018783 [ RunTime:0.002453s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (157235,135940,648871,104608,307802,501094,785598,337753,241407,621132,886158,772166,1038980,791945,481358,715151,352430,177327,658325,233153,395571,92672,715217,693214,133218,839564,265238,637991,614684,986229,693727,915213,947647,537427,367743,109103,91287,754767,891767,505245,736275,795310,25919,156420,908667,356030,95481,355584,226527,962930,402822,670598,565392,283733,605899,508340,257676,71815,784189,574210) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001314s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1018783 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1018783 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000538s ]