SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001228s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 332194 LIMIT 1 [ RunTime:0.000319s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 332194 [ RunTime:0.003204s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (13253,809663,1035613,1005278,989598,689190,556672,492870,1046366,283509,272557,967255,357540,954629,720768,1036683,1025848,1038844,1030874,669232,121972,456575,633899,507287,94153,930230,768318,871655,810011,334806,867121,472204,156947,976566,959472,148949,1042992,909900,374136,353584,584293,545991,634299,480701,895426,294499,267142,807008,51171,205961,185214,254759,901894,904157,674884,216930,579217,683850,239109,804087) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001016s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 332194 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000771s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 332194 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000614s ]