SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001207s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 198160 LIMIT 1 [ RunTime:0.000366s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 198160 [ RunTime:0.001787s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1041234,142755,821081,891922,702331,420050,161622,157231,802002,229852,68709,886675,851685,511118,871057,284272,939993,227972,850185,142360,716816,652887,44689,613724,721278,743040,555534,472897,816656,743150,468747,532743,336497,932035,141651,223377,233908,342880,717933,502711,874790,97855,985139,230303,55244,777078,953601,411170,770246,288594,592141,964564,967950,16489,419243,165650,759141,176713,305233,309520) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001466s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 198160 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000467s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 198160 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000510s ]