SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001431s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1038705 LIMIT 1 [ RunTime:0.000812s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1038705 [ RunTime:0.001861s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (671680,4026,596735,98722,945217,945195,511440,647337,877597,19819,574431,78278,92303,853027,433767,338403,645158,431630,371323,419285,154257,818278,446852,974362,231323,782851,972655,43732,55228,712648,146210,484601,773829,629656,372062,340928,436966,420408,645386,718495,995429,100734,94873,367378,582008,713049,765750,585603,541371,302605,1018476,544747,816012,520136,473496,483930,601897,25976,609808,801159) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001091s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1038705 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1038705 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000429s ]