SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001142s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 201140 LIMIT 1 [ RunTime:0.000357s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 201140 [ RunTime:0.001632s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (855349,850828,920222,108721,216154,111124,689644,131611,486712,698351,1040930,722771,85382,917791,458294,435318,485239,918647,148551,522815,587385,430541,212980,818470,1004806,536534,100128,89399,875548,990520,766396,204772,764495,107747,649098,153315,175862,296368,989522,451623,349348,347325,177596,871835,1030617,807844,976433,529193,614167,372667,317301,986619,622638,1031495,94505,647763,1036225,643119,1039100,522351) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001305s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 201140 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000436s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 201140 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000596s ]