SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001146s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1004880 LIMIT 1 [ RunTime:0.000737s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1004880 [ RunTime:0.001792s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (420799,786715,22330,106198,866064,330082,1012674,312764,678513,255216,773832,151367,997379,1036827,560728,949425,218643,769917,665561,374134,28310,324821,228212,874373,62771,901756,881559,930440,148593,821932,446015,617157,44166,989215,500828,550117,577135,1026185,162018,92475,671424,989820,878347,343590,269007,576769,221410,848704,799333,813695,582180,761389,467342,620618,506071,512823,94408,96966,1033621,743558) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001262s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1004880 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000476s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1004880 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000622s ]