SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003315s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505102 LIMIT 1 [ RunTime:0.003406s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505102 [ RunTime:0.007210s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (577896,779597,182444,372206,386731,1047517,196092,741261,253297,473496,339580,451668,718591,901875,536831,461460,541338,1035539,378561,762858,832330,204170,1022292,1038714,124904,544936,123435,1023243,812116,847621,321463,868136,399764,850367,783361,931259,703611,473078,836538,323080,139797,724029,587616,285983,914829,916323,266432,740513,598666,833462,78851,689669,464043,115996,494306,128598,273298,647423,406178,723794) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002142s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505102 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000349s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505102 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000604s ]