SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001129s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1014041 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1014041 [ RunTime:0.001639s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (118920,1044748,540406,66187,620715,67871,111854,215147,123813,824283,918761,569073,143136,404090,31889,676753,441446,842203,340751,989376,277707,308217,796300,169007,804659,463282,908944,269379,642940,955858,600048,730907,535452,884558,714592,279853,469930,662869,155158,907790,921050,713808,524404,425210,482861,958812,398801,120127,503412,242717,129465,555739,893881,277283,839701,730560,145275,459339,711521,853463) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001103s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1014041 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1014041 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000464s ]