SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001233s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 262591 LIMIT 1 [ RunTime:0.000392s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 262591 [ RunTime:0.001671s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (74300,887481,361716,1017298,501072,234296,197192,75932,382938,308048,174861,811950,943858,430827,130079,149893,277248,776595,715086,879260,699603,934019,184784,427578,716441,105340,179950,909747,259322,964628,531618,514667,707959,882052,627312,924305,332149,153210,579614,365086,222028,501223,285708,423185,663925,933246,545239,750045,786968,301407,747292,495571,563811,844639,701288,465999,98189,661262,633839,534203) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000955s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 262591 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 262591 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000493s ]