SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001240s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 471041 LIMIT 1 [ RunTime:0.000392s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 471041 [ RunTime:0.001840s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (548606,268787,298080,158166,663160,857086,923292,854512,542283,187678,61443,471742,171892,482095,1006469,454716,21475,776208,1014834,613308,254485,6521,504030,436012,52314,556182,891802,721547,204614,337823,480417,855733,1011403,327124,1046694,235046,661422,763272,503628,345335,65954,1048781,252326,503810,1039147,408878,892260,844309,585186,541959,831253,110324,387130,865157,44545,556403,582841,209102,586523,857094) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 471041 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000389s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 471041 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000407s ]